﻿CREATE TABLE [dbo].[tblOwner] (
    [OwnerID]                      INT            IDENTITY (1, 1) NOT NULL,
    [LongName]                     NVARCHAR (100) NOT NULL,
    [ShortName]                    NVARCHAR (50)  NULL,
    [AllowPartialShipments]        BIT            NOT NULL,
    [PreferredCarrierCode]          CHAR (1)       NULL,
	[CashAccountID]				int	null,
	[ProductRevenueAccountID] 	int null,
	[InventoryAccountID]		int	null,
	[CostOfGoodsSoldAccountID]	int	null,
	[CostOfGoodsAdjustmentAccountID] int null,
	[ShippingCostAccountID]		int	null,
	[ShippingRevenueAccountID]	int	null,
	[TaxRevenueAccountID]	int null,
	[MiscExpenseAccountID] int null,
	[RetryCardDelay] int null,
	[RetryCardCount] int null,
	[PackingSlipReport] nvarchar(50) null
);

